node ODBC

安装

1
npm install -g node-odbc

node odbc

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
var odbc = require('node-odbc');
let conn = new odbc.Connection().connect('DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=localhost;UID=root;PWD=root;DATABASE=dqmm');
let conn = new odbc.Connection().connect('Dsn=mysqldb;UID=root;PWD=root;DATABASE=dqmm');
//返回一行
conn.executeQuery((res, err) => 
    {
        if( err != null )
        {
            console.log( err );
        }
 
        console.log( res); 
    },
    "SELECT * FROM dq_bz_rule"
);

//返回多行
conn.executeQuery(1,(res, err) => 
    {
        if( err != null )
        {
            console.log( err );
        }
        console.log(res);
    },
    "SELECT * FROM dq_bz_rule"
);

//Json遍历key
for(var key in res){
    console.log(key);
}
     
//Json遍历value
for(var key in res){
    console.log(res[key]);
}